package org.springblade.modules.notice.constant;

/**
 * @Author ysq
 * @Date 2025/08/04
 * @Description 救援变量常量
 */
public interface RescueVariableConstant {

	/**
	 * 救援工单基础信息
	 */
	String WORKER_INFO = "SELECT\n" +
		"\tt1.plan_id AS planId,\n" +
		"\tt1.elevator_id AS elevatorId,\n" +
		"\tt1.building_id AS buildingId,\n" +
		"\tt1.address AS elevatorAddress,\n" +
		"\tt1.floor,\n" +
		"\tt2.`name` AS projectName,\n" +
		"\tt2.address AS projectAddress,\n" +
		"\tNOW() AS curTime,\n" +
		"\tt3.real_name AS createUser \n" +
		"FROM\n" +
		"\tblade_maintain_malfunction_rescue t1\n" +
		"\tLEFT JOIN blade_building t2 ON t1.building_id = t2.id\n" +
		"\tLEFT JOIN blade_user t3 ON t1.create_user = t3.id \n" +
		"WHERE\n" +
		"\tt1.plan_id = ?";
}
